The Stock Movements group of fields on the Config GL Interface screen allows you to customise the integration of stock movements and adjustments to the General Ledger.
To complete the Stock Movements fields:
Refer to "Edit - General Ledger Config - Distribution Interface".
Micronet displays the Stock Movements fields.
Select an integration option:
|
Option |
Description |
|
Total |
The Distribution system searches for a GL interface record labelled TOTAL and produces accounting entries (financial transactions) based on the GL accounts entered in that table. This is the standard, multi-purpose GL interface record setup to accumulate financial transactions where customisation is not required. |
|
Combination |
Ungreys the fields below (Warehouse Key and Item Key) allowing you to select exactly how you want stock movement transactions dissected. This allows data to be transferred from the Distribution system based on the interrelations between the files that comprise your permanent records. For an example of how the Combination option works, refer to "Configuring MDS Integration". |
Where multiple warehouses exist, Stock on Hand can be divided into separate GL accounts in the Balance Sheet of the General Ledger.
Warehouses can be dissected and reported in one of the following ways:
|
Option |
Description |
GL Interface |
Master file update |
|
None |
No dissection by warehouse |
-- |
-- |
|
Ware(house) Item |
When stock is adjusted/transferred or cost prices are amended/updated, Micronet determines the relevant warehouse on an item-by-item basis and updates the specified Stock on Hand GL account and/or Cost of Sale GL account |
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |
|
Warehouse |
When stock is adjusted/transferred or cost prices are amended/updated, Micronet updates the relevant GL accounts based on where the item is being held and stored. |
GL interface records need to be setup and assigned to each warehouse record |
Warehouse master file - GL Interface field (refer to "File - Warehouse - Warehouse") |
Item Key
Stock on Hand can be divided into various GL accounts based on the individual items in the inventory files.
Stock movements can be dissected and reported in one of the following ways:
|
Option |
Description |
GL Interface |
Master file update |
|
None |
No dissection by item key |
-- |
-- |
|
Item |
As each item is adjusted/transferred or cost prices are amended/updated, Micronet updates the individual stock accounts setup in the General Ledger based on the integration specifications for each item. |
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |
|
Category |
As each item is adjusted/ transferred or cost prices are amended/updated, Micronet produces financial transactions and transfers them to the General Ledger based on the item's product category. |
GL interface records need to be setup and assigned to each product category |
Product Category master file - GL Interface field (refer to "File - Product Category - Category") |
|
Barcode |
As each item is adjusted/ transferred or cost prices are amended/updated, Micronet identifies the barcode assigned to the item and updates the individual stock accounts in the General Ledger based on the item and its barcode. |
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |